package com.example.fp.wrt.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.fp.wrt.entity.Liveness;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 说明: 用户活跃度表操作接口
 * 编写人: 魏仁涛
 * 编写时间: 2019-12-31
 * 修改时间:
 */
@Mapper
public interface LivenessMapper extends BaseMapper<Liveness> {
    @Select("SELECT appname as App, count(*) as Mindex FROM liveness group by appname")
    public List<Liveness> selectAllLiveness();

    @Select("select appname,Mindex from liveness LIMIT 10")
    public List<Liveness> echartzhuxingtu();

    @Select("select appname,Dindex  from liveness LIMIT 5")
    public List<Liveness> echartbingtu();
}
